﻿CREATE TABLE [dbo].[JobTemplateDetail] (
    [JobTemplateId]  INT NOT NULL,
    [JobAttributeId] INT NOT NULL,
    [HasRange]       BIT NULL,
    [IsMultiChoices] BIT NULL,
    CONSTRAINT [PK_JobTemplateDetail] PRIMARY KEY CLUSTERED ([JobTemplateId] ASC, [JobAttributeId] ASC),
    CONSTRAINT [FK_JobTemplateDetail_JobAttribute] FOREIGN KEY ([JobAttributeId]) REFERENCES [dbo].[JobAttribute] ([JobAttributeId]),
    CONSTRAINT [FK_JobTemplateDetail_JobTemplate] FOREIGN KEY ([JobTemplateId]) REFERENCES [dbo].[JobTemplate] ([JobTemplateId])
);





